Selecting Fields

To create a query, you must select fields from the Sales field list.

Click the down arrow on the scroll bar in the Sales field list until the Dept field appears.

Double-click Dept in the Sales field list


    Access immediately adds Dept to the Field Row. Access also indicates in the Table row that this field comes from the Sales table.

Double-click Descript in the Sales field list


    Access adds Descript to the Field Row.

Double-click Trans in the Sales field list


    Access immediately adds Trans to the Field row.

Now your turn! Try it!